HousingLease 
EntityType  Independent 
Logical Entity Name  HousingLease 
Default Table Name  HSStudentLeaseHistory 
Logical Only  NO 
Definition 
 
Note 
 

HousingLease Attributes 
Attribute/Logical Rolename  Domain  Datatype  NULL  Definition 
HSStudentLeaseHistoryID(PK)    INTEGER  NO 
 
StartDate    DATETIME  NO 
 
MoveOutDate    DATETIME  YES 
 
EndDate    DATETIME  NO 
 
ActualEndDate    DATETIME  YES 
 
AdTermID(FK)    INTEGER  YES 
 
HSLeaseStatusID(FK)    INTEGER  NO 
 
SyStudentID(FK)    INTEGER  NO 
 
HSBuildingRoomsID(FK)    INTEGER  NO 
 
HSStudentApplicationID(FK)    INTEGER  NO 
 
HSMoveOutReasonID(FK)    INTEGER  YES 
 
LeaseAmount    MONEY(19, 4)  NO 
 
Frequency    CHAR(1)  NO 
 
TerminationFee    MONEY(19, 4)  YES 
 
SaBillCodeID(FK)    INTEGER  YES 
 
UserID    INTEGER  NO 
 
DateAdded    DATETIME  NO 
 
DateLstMod    DATETIME  NO 
 
ts    TIMESTAMP/DATE  NO 
 
LastPrintDate    DATETIME  YES 
 
StudentEnrollmentPeriodId(FK)    INTEGER  YES 
 
FaStudentAYID(FK)    INTEGER  YES 
 
Reason    VARCHAR(max)  YES 
 
DateSelectedOn    CHAR(1)  YES 
 
IsAcademicYearLease    BIT  NO 
 
SaTransCodeID(FK)    INTEGER  YES 
 
SaBillTermID(FK)    INTEGER  YES 
 
ManuallyUpdateDates    BIT  NO 
 
LastFrequency    CHAR(1)  YES 
 
RoomSwitchDate    DATETIME  YES 
 
StartDateOnRoomSwitch    DATETIME  YES 
 

HousingLease Keys 
Key Name  Key Type  Keys 
HSStudentLeaseHistory_HSMoveOutReasonID_N_N_IDX  Inversion Entry  HSMoveOutReasonID 
HSStudentLeaseHistory_HSLeaseStatusID_N_N_IDX  Inversion Entry  HSLeaseStatusID 
HSStudentLeaseHistory_AdTermID_N_N_IDX  Inversion Entry  AdTermID 
HSStudentLeaseHistory_HSBuildingRoomsID_NU_NC_IDX  Inversion Entry  HSBuildingRoomsID 
HSStudentLeaseHistory_SyStudentID_N_N_IDX  Inversion Entry  SyStudentID 
HSStudentLeaseHistory_SaBillCodeID_N_N_IDX  Inversion Entry  SaBillCodeID 
HSStudentLeaseHistory_HSStudentApplicationID_N_N_IDX  Inversion Entry  HSStudentApplicationID 
HSStudentLeaseHistory_StartDate_EndDate_NU_NC_IDX  Inversion Entry  StartDate, EndDate 
HSStudentLeaseHistory_HSStudentLeaseHistoryID_U_C_IDX  PrimaryKey  HSStudentLeaseHistoryID 

HousingLease Relationships 
Parent Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Supertype 
Term  Non-Identifying  Zero or One to Zero or More        AdTermID  NO 
HsBuildingRooms  Non-Identifying  One To Zero or More        HSBuildingRoomsID  NO 
HSLeaseStatus  Non-Identifying  One To Zero or More        HSLeaseStatusID  NO 
HSMoveOutReason  Non-Identifying  Zero or One to Zero or More        HSMoveOutReasonID  NO 
HousingApplicationStudent  Non-Identifying  One To Zero or More        HSStudentApplicationID  NO 
BillingTransactionCode  Non-Identifying  Zero or One to Zero or More        SaBillCodeID  NO 
Student  Non-Identifying  One To Zero or More        SyStudentID  NO 
StudentEnrollmentPeriod  Non-Identifying  Zero or One to Zero or More        StudentEnrollmentPeriodId  NO 
StudentAcademicYear  Non-Identifying  Zero or One to Zero or More        FaStudentAYID  NO 
Term  Non-Identifying  Zero or One to Zero or More        SaBillTermID  NO 
BillingTransactionCode  Non-Identifying  Zero or One to Zero or More        SaTransCodeID  NO 
Child Relationships: 
Entity Name  Type  Cardinality  Business Name  VerbPhrase  InversePhrase  Foreign Keys  Is Subtype 
HsBuildingRoomsStudents  Non-Identifying  One To Zero or More          NO 
HousingLeaseScheduledCharge  Non-Identifying  One To Zero or More          NO 
HousingLeaseDocument  Non-Identifying  One To Zero or More          NO 
HSStudentLeaseEvent  Non-Identifying  One To Zero or More          NO 

HousingLease Check Constraints 
Check Constraint Name  CheckConstraint